package com.yixuan.mt.common.utitls;

public class EventsUtils {
    public static String getMysqlEventsTableSQL(String table) {
        return "CREATE TABLE `" + table + "` (\n" +
                "  `id` int NOT NULL AUTO_INCREMENT,\n" +
                "  `name` varchar(200) CHARACTER SET utf8mb4 NOT NULL,\n" +
                "  `parent` varchar(300) CHARACTER SET utf8mb4 NOT NULL,\n" +
                "  `size` bigint,\n" +
                "  `type` varchar(100) CHARACTER SET utf8mb4 NOT NULL,\n" +
                "  PRIMARY KEY (`id`)\n" +
                ") DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;";
    }

    public static String getMysqlEventsInsertSQL(String table) {
        return "insert into " + table + " (name, parent, type, size) values (?, ?, ?, ?)";
    }
}
